Fix some breaking tests with nested transactions

[iamareebjamal]

After enabling nested transactions in #6981, some tests which were relying on auto increment IDs starting from 1 were broken, because IDs are not reset when transactions are rolled back, they're reset only when schema is dropped. Hence, I reverted those tests to old format, which is quite slow, 10s instead of 1s

Furthermore, factories should not really depend on the IDs being 1 or a specific number, hence factories need to be fixed so that nested transactions can be enabled for every test

[spy-1234]

I will do this thing better