SQL Server Identity column value suddenly jumps to 1002

Identity will never decrease its value

1. If record is delete that value will never been assigned to othe record.

2. If insert fails that time also Identity is incremented. Though no record is inserted.

You need to insert record in such a way that first you need to get the Max (Id) + 1 from table and insert the record with this Id.