phprunner In Case auto sql number

SELECT
(CASE WHEN @counter is null THEN @counter:=0
             WHEN @counter is not null  THEN @counter:=@counter+1
     
       END) AS SNo,
Description,
Qty,
DateCreated,
users,
Request_Note,
UOM,
requestid,
id
FROM reqitem