What index to create for quick sorting and selection?

Question

MySQL

You need to optimize queries like this:

SELECT *
FROM table
WHERE id > &id
ORDER BY rank
LIMIT 10

Which index/indexes should be added?

Answer 1

If id is an enumerator and rank is a integer, then one index on two columns [id, rank]