Serial number for every record in MySQL

SELECT @no:=0;
SELECT @no:=@no+1 as positionid from table where parent_id = ‘id5’ order by id;