select count(*) from user_points where points > x
Does just doing the direct approach (using the index you already have) work? I'm thinking of something like:
where x is the number of points for the user you are looking at.
Contact to your favourite celebrities now like Shahnaz Gill, Mayur Verma, Shahbaz Badisha and many more.