After delete data ID no is same not changed. e.g 1 2 3 If i delete 2 then it shows 1 3 I want to show 1 2

Create procedure [dbo].[spDelete1] @Id int = null as begin set identity_insert StudentTest on -- Delete will only work if no referencing FK's delete StudentTest where ID = @Id set identity_insert StudentTest on insert into StudentTest (Id,Name) select @Id,Name from StudentTest where Id = @Id+1 set identity_insert StudentTest off delete StudentTest where ID = @Id+1 DBCC CHECKIDENT(StudentTest, RESEED, 1); DBCC CHECKIDENT(StudentTest, RESEED); end