Use counters for sequences with local caches in Infinispan embedded

Until Infinispan 9.2.CR1 counters work only for clustered caches, this should change in a later release.

We should keep track of it and make sure that sequences and counters can also be used for local caches in Hibernate OGM.

This also means we need to remove the method TestHelper.enableCountersForInfinispan and tests for both local caches and cluster caches where it make sense