Set auto_increment_offset explicitly in tests.

Fixes [RT83487](https://rt.cpan.org/Ticket/Display.html?id=83487)

Also I switched to use temporary tables which is recommended in the
DBI guidelines and which saves 'drop table' and 'drop table if exists'