This avoid an unnecessary FOR UPDATE lock on internal id records when
the iid value has been generated internally anyways.

The lock is still required to track any values that come in through
other means, i.e. set by a user (through the API).

The broader picture is in
https://gitlab.com/gitlab-org/gitlab/issues/30515.