Can replace line 4 by since you alreay have lastid

SELECT @NewID =(LTRIM(SUBSTRING(@LastID,2,60)+1)) FROM test

all the best