You can add the new column as Identity field. In case the Identity already exists . while adding the record in the table, you will have to do the below:
DECLARE @MAX AS INT
SELECT @MAX = ISNULL(MAX(NEWCOLUMN) + 1,1) FROM TABLE_1
INSERT INTO TABLE_1 (NEWCOLUMN, EXISTINGCOLUMN)
VALUES (@MAX,'TEST')