Move `reset_pk_sequence!` test to `AdapterTestWithoutTransaction`
Move `reset_pk_sequence!` test to `AdapterTestWithoutTransaction`

If execute PostgreSQL test with specifying 53853 for seed, the following
error will occur.

```
  1) Error:
TransactionTest#test_restore_custom_primary_key_after_rollback:
ActiveRecord::RecordNotUnique: PG::UniqueViolation: ERROR:  duplicate key value violates unique constraint "movies_pkey"
DETAIL:  Key (movieid)=(2) already exists.
: INSERT INTO "movies" ("name") VALUES ($1) RETURNING "movieid"
```

travis is here https://travis-ci.org/rails/rails/jobs/254095918

As with #29287, it seems like a problem that the value of primary key
obtained from connection gets different.
Therefore, fixed to execute that test within transaction.

notapatch/rails,MSP-Greg/rails,printercu/rails,mohitnatoo/rails,baerjam/rails,joonyou/rails,assain/rails,illacceptanything/illacceptanything,shioyama/rails,flanger001/rails,gcourtemanche/rails,assain/rails,deraru/rails,bogdanvlviv/rails,EmmaB/rails-1,palkan/rails,flanger001/rails,esparta/rails,untidy-hair/rails,gauravtiwari/rails,tgxworld/rails,gfvcastro/rails,illacceptanything/illacceptanything,Stellenticket/rails,repinel/rails,kirs/rails-1,BlakeWilliams/rails,fabianoleittes/rails,mathieujobin/reduced-rails-for-travis,iainbeeston/rails,utilum/rails,Envek/rails,tjschuck/rails,notapatch/rails,deraru/rails,illacceptanything/illacceptanything,illacceptanything/illacceptanything,schuetzm/rails,Erol/rails,assain/rails,arunagw/rails,mathieujobin/reduced-rails-for-travis,iainbeeston/rails,kmayer/rails,rails/rails,baerjam/rails,jeremy/rails,ledestin/rails,jeremy/rails,mechanicles/rails,aditya-kapoor/rails,deraru/rails,travisofthenorth/rails,odedniv/rails,vipulnsward/rails,illacceptanything/illacceptanything,yhirano55/rails,fabianoleittes/rails,pvalena/rails,Stellenticket/rails,mohitnatoo/rails,starknx/rails,palkan/rails,Vasfed/rails,georgeclaghorn/rails,ledestin/rails,fabianoleittes/rails,printercu/rails,pvalena/rails,schuetzm/rails,gauravtiwari/rails,kirs/rails-1,illacceptanything/illacceptanything,MSP-Greg/rails,arunagw/rails,mohitnatoo/rails,MSP-Greg/rails,rafaelfranca/omg-rails,gfvcastro/rails,illacceptanything/illacceptanything,repinel/rails,yasslab/railsguides.jp,tgxworld/rails,printercu/rails,Vasfed/rails,tgxworld/rails,Envek/rails,joonyou/rails,yalab/rails,prathamesh-sonpatki/rails,prathamesh-sonpatki/rails,mathieujobin/reduced-rails-for-travis,illacceptanything/illacceptanything,yawboakye/rails,yahonda/rails,esparta/rails,Stellenticket/rails,schuetzm/rails,arunagw/rails,yawboakye/rails,felipecvo/rails,kaspth/rails,travisofthenorth/rails,Envek/rails,fabianoleittes/rails,Vasfed/rails,kaspth/rails,joonyou/rails,esparta/rails,shioyama/rails,georgeclaghorn/rails,kddeisz/rails,rafaelfranca/omg-rails,betesh/rails,betesh/rails,utilum/rails,yahonda/rails,iainbeeston/rails,kmcphillips/rails,kddeisz/rails,Edouard-chin/rails,illacceptanything/illacceptanything,mohitnatoo/rails,BlakeWilliams/rails,Erol/rails,yasslab/railsguides.jp,lcreid/rails,lcreid/rails,kmayer/rails,Erol/rails,prathamesh-sonpatki/rails,illacceptanything/illacceptanything,utilum/rails,gcourtemanche/rails,felipecvo/rails,alecspopa/rails,yhirano55/rails,printercu/rails,MSP-Greg/rails,kddeisz/rails,jeremy/rails,palkan/rails,illacceptanything/illacceptanything,pvalena/rails,jeremy/rails,kamipo/rails,Erol/rails,kmcphillips/rails,yhirano55/rails,lcreid/rails,gfvcastro/rails,yahonda/rails,rails/rails,yawboakye/rails,illacceptanything/illacceptanything,Edouard-chin/rails,baerjam/rails,travisofthenorth/rails,felipecvo/rails,kamipo/rails,illacceptanything/illacceptanything,alecspopa/rails,starknx/rails,shioyama/rails,yahonda/rails,betesh/rails,tjschuck/rails,travisofthenorth/rails,vipulnsward/rails,mechanicles/rails,Edouard-chin/rails,flanger001/rails,tjschuck/rails,rails/rails,repinel/rails,aditya-kapoor/rails,untidy-hair/rails,Stellenticket/rails,Envek/rails,rafaelfranca/omg-rails,kmcphillips/rails,esparta/rails,tjschuck/rails,gauravtiwari/rails,yalab/rails,brchristian/rails,assain/rails,joonyou/rails,gfvcastro/rails,starknx/rails,aditya-kapoor/rails,yalab/rails,pvalena/rails,vipulnsward/rails,kmayer/rails,baerjam/rails,untidy-hair/rails,odedniv/rails,ledestin/rails,iainbeeston/rails,Sen-Zhang/rails,bogdanvlviv/rails,palkan/rails,deraru/rails,kaspth/rails,odedniv/rails,utilum/rails,repinel/rails,georgeclaghorn/rails,eileencodes/rails,Edouard-chin/rails,EmmaB/rails-1,alecspopa/rails,mechanicles/rails,flanger001/rails,gcourtemanche/rails,illacceptanything/illacceptanything,Sen-Zhang/rails,tgxworld/rails,illacceptanything/illacceptanything,BlakeWilliams/rails,notapatch/rails,EmmaB/rails-1,aditya-kapoor/rails,Vasfed/rails,vipulnsward/rails,mechanicles/rails,brchristian/rails,arunagw/rails,notapatch/rails,georgeclaghorn/rails,shioyama/rails,yhirano55/rails,brchristian/rails,prathamesh-sonpatki/rails,yasslab/railsguides.jp,yasslab/railsguides.jp,kamipo/rails,Sen-Zhang/rails,eileencodes/rails,eileencodes/rails,rails/rails,kirs/rails-1,schuetzm/rails,kddeisz/rails,betesh/rails,eileencodes/rails,lcreid/rails,bogdanvlviv/rails,untidy-hair/rails,BlakeWilliams/rails,yalab/rails,yawboakye/rails,kmcphillips/rails,bogdanvlviv/rails