select top 10 *

from yourtable eu

where

    eu.col1 not in (select top 20 col1 from yourtable eu order by eu.col1)

order by

    eu.col1

It might and WILL create a heavy load when you have lot's of data, so make sure you test the performance before going live with it. There are other methods to do it like cursors, starting from 'bigger then last' etc. At least be sure that you have indexes/primary keys on those columns you use for sorting or in where-clause.

P.S. Since such queries are serious performance issues w/many systems with utopic DBA's, i respect microsoft's decision in making mysql style 'limit 500,100' a little more complicated.