I'll think you'll need to edit the query for that.

Code: 
SELECT * FROM tblLulz WHERE fldPrimaryKey > ((SELECT MAX(fldPrimaryKey) FROM tblLulz) - 10) ORDER BY DESC
I'm not sure you can use custom queries in wordpress.

edit:

Or do what gavo said..

He suggests to put your result in an array, and then sort the array.
Which works too.