mysql_rownumber

SET @rowNum = 0;

SELECT userid,@rowNum:=@rowNum+1 AS rowNo FROM ol_user ORDER BY userid DESC LIMIT 10;