And there was me thinking it was:

SELECT * FROM table
  LIMIT 99, 21;
[download]

No WHERE clause in sight. If you want be be a bit more specific on how things are ordered (rather than insertion order (which I believe is defined as being the standard ordering)), you do

SELECT * FROM table
  ORDER BY col
  LIMIT 99, 21;
[download]

Still no WHERE clause.