MySQL select specific value from duplicated rows

I have table like this

id name       value

1  Leo        0
2  Ethan      0
3  Claire     0
4  Leo        1
5  Claire     1
6  Ethan      0

I would like to get result like below:

id name       value

2  Ethan      0
4  Leo        1
5  Claire     1

It looks pretty easy but I have struggled with it for hours, please advise and give hints. thanks.