SELECT * FROM your_table WHERE id > (SELECT id FROM your_table ORDER BY id LIMIT 10000, 1) ORDER BY id LIMIT 10;