mysql> SELECT `id` FROM `prefix_table` ORDER BY `id` DESC LIMIT 10;
+----------+
| id |
+----------+
| ******** |
| ******** |
| ******** |
| ******** |
| ******** |
| ******** |
| ******** |
| ******** |
| ******** |
| ******** |
+----------+
10 rows in set (0.00 sec)
mysql> SELECT `id` FROM `prefix_table` ORDER BY `id` DESC LIMIT 5000000, 10;
+----------+
| id |
+----------+
| ******** |
| ******** |
| ******** |
| ******** |
| ******** |
| ******** |
| ******** |
| ******** |
| ******** |
| ******** |
+----------+
10 rows in set (3.39 sec)
mysql>