SELECT 
    @rownum:=@rownum + 1 AS RNUM
    , a.*
FROM
    some_table AS a,
    (SELECT @rownum:=0) AS R
WHERE
    a.some_column = 1
ORDER BY 1;