Climate-driven variability in the occurrence of major floods across North America and Europe