how to add rows number using mysql query

select @rownum:=@rownum+1 ‘rowid’, p.* from menu p,  

(SELECT @rownum:=0) r order by id desc limit 10;