Really good question, tricky and nice.

Obviously the default value for IDENTITY_INSERT is OFF, only by changing it to ON, you wouldn't be able to insert any of the rows as values for column 1 should be provided. (That was the tricky part, setting to OFF does not do any)

Also nice to note that the failed INSERT statements would affect the identity value for the table, though the row didn't end up there.

Thanks