How to Generate Auto Increment IDs

DECLARE @Increment INT=1
DECLARE @NewProjectCode VARCHAR(100)

WHILE @Increment<100
BEGIN
SET @NewProjectCode='EMP'+ Right('0000'+CAST(@Increment as VARCHAR(4)),4)


PRINT @NewProjectCode
SET @Increment=@Increment+1
END