The idea is always the same and can be adjusted to select any position. First you have to order the query and select the first 19 values (Let's say we want the 20th to 30th highest score in a competition). Then exclude the first 19 rows, and return the next 10 rows. This will give you the 20th to 30th highest score.

SELECT * FROM competition WHERE id NOT IN (SELECT id FROM competition ORDER BY score DESC LIMIT 19) ORDER BY score DESC LIMIT 10

Wouldn't this also do the trick?
SELECT * FROM competition ORDER BY score DESC LIMIT 19,10;

Dimitar, Good point :-)

SELECT TOP (10) ShippingId
FROM Shipping
WHERE (ShippingId NOT IN
(SELECT TOP (20) ShippingId
FROM Shipping AS Shipping_1
ORDER BY ShippingId DESC))
ORDER BY ShippingId DESC