[Backport 1.4.latest] upgrade macos version (#10974) #33465

Job	Run time
code-quality	1m 33s
unit test / python 3.9	1m 32s
unit test / python 3.10	1m 34s
build packages	44s
unit test / python 3.11	1m 22s
integration test / python 3.9 / ubuntu-20.04	12m 29s
integration test / python 3.10 / ubuntu-20.04	12m 32s
integration test / python 3.11 / ubuntu-20.04	11m 27s
integration test / python 3.9 / windows-latest	16m 15s
integration test / python 3.9 / macos-14	7m 5s
	1h 6m 33s

Provide feedback