I am using ASP.NET Core Identity for my uni project, but to match the project's requirements I changed primary key type to int. Everything works fine, each new record has last added record's Id incremented by 1.

While testing many features I had been deleting some records. When I want to add some data, either by Register class or SeedData new records continue to appear in database with Id of last added record incremented by 1 (even though no records exist in the table), like