How to generate auto increment values for my duplicate column in my sql?
Try this one, execute one at a time set variable and select statement.

SET @Variable:=0;
SELECT @Variable:=@Variable+1 AS AddNewColumn,ID,Title,Lscno 
FROM tutorials_tbl
WHERE Lscno IN (
    SELECT Lscno
    FROM tutorials_tbl
    GROUP BY Lscno
    HAVING COUNT(Lscno) &gt; 1
)ORDER BY Lscno