Enforce REQUIRES_NEW for correct transaction configuration on transactional event listeners

[jhoeller]

Following up on #30679 (comment), we decided to make the check more restrictive: only accepting @Transactional when declared with REQUIRES_NEW on an @TransactionalEventListener method.