Which index to create for quick sorting and selection?

Need to optimize queries like this:
SELECT *
FROM table
WHERE id > &id
ORDER BY rank
LIMIT 10

What index/indexes should I add?
August 19th 19 at 22:41
1 answer
August 19th 19 at 22:43
Solution
If id is the numerator, and rank - doralee, then a single index on two columns [id, rank]

Find more questions by tags DatabasesMySQL