You can filter and sort the records as you want using the Recordset object. Just use rs.Filter and rs.Sort properties ( whichever you need ).
For example, add following two lines below rs.Open line in this article example ( 'paging.asp' ) code to see the results getting sorted and filtered:
rs.Filter = "id > 10"
rs.Sort = "first_name"
The rs.Sort property should be a set to one or more comma separated column-names for records to get sorted on.
Enjoy.