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.