tests: Fix failures since pytest-django 4.5.0 release

Setting the reset_sequences parameter from the pytest.mark.django_db decorator to True implies to also set the transactional one to True.

That requirement was hardened in latest pytest-django release.

---

Migrated from D6718 (view on Phabricator)