Table Sorting and Limit Question

Currently we have a table with a sequence number( id ) as a primary key,
a date field which is indexed and several other columns. The user
interface allows the user to sort the data by date and limits the result
set to 100 rows. 

The question is: 
The user interface needs the capability to sort the table by date but
pull out the hundred row set that contains id say...542 for example. 

What would be the best way to do this taking into account this table is
several hundred thousand rows? 


Dawn Hollingsworth 
Principal Engineer 
AirDefense, Inc.