SQL Query - to fetch ROW ID

select * from (SELECT @row := @row + 1 as row1, t.* FROM cms_users t, (SELECT @row := 0) as r order by t.id) as n where n.row1  2