SELECT * FROM table WHERE id BETWEEN 250
AND 300 ORDER BY value ASC
If I run something like this, it explicitly orders only the 50 records
separate from the others. You see, I want those to be ordered against
the entire list -- and grab specified ranges.