• A good question.

    In the explanation:

    So although we deleted the row with i = 104 (while IDENTITY_INSERT is still ON) it does not reuse this value nor does it use / fill the gap between 3 and 102.


    Note that whether IDENTITY_INSERT is turned OFF either before or after the row is deleted, the result is the same.  It doesn't reuse the value.