If I have this table

ID User
1 A
3 B
6 C
8 D


How can I know the no of row that it's ID=6 ?

the no of row that it's ID=6 here is 3