如何从MySQL和PHP的500万行记分板中获得排名？

I have a leaderboard which has a "score" column. I also have an index on the score column which allows me to order the table by score very quickly, even slicing out the top ten or any number of scores - even with 5 million rows!I have a leaderboard which has a "score" column