Mysql/php next page with an ORDER BY

I have a list of links that are sorted alphabetically by MySQL, then put into a php page. is there any way, in php (or mysql) to be able to create a link that would go from the first returned row alphabetically to the next one.
So say I have something like this:
ID---------------FRUIT
3----------------APPLE
2----------------BANANA
5----------------CHERRY
1----------------GRAPE
4----------------ORANGE

how could I create it so I could go from apple to banana to cherry to grape to orange.