Row ID in Mysql and Using it for Serial Number

SET @rownum := 0;
select @rownum :=@rownum + 1 AS rank,EmpID,EmpName,EmpCity from employeedetails where empname ='kiran'


Carry over a value from previous row.