Spring Enforce REQUIRES_NEW for correct transaction configuration on transactional event listeners

Following up on https://github.com/spring-projects/spring-framework/issues/30679#issuecomment-1757848560, we decided to make the check more restrictive: only accepting @Transactional when declared with REQUIRES_NEW on an @TransactionalEventListener method.