[stable27] fix(sync): prevent race condition by relying on autoincrement

[stable27] fix(sync): prevent race condition by relying on autoincrement #7822