Fix CI failure due to manylinux2014 and rhel8 incompatibility, deprecated MS server 2019 & intel-oneapi download errors #3144

Job	Run time
build-and-test-cpp-x86_64 (ubuntu-22.04, mkl)	5m 47s
build-and-test-cpp-aarch64 (openblas)	5m 41s
build-and-test-cpp-x86_64 (ubuntu-22.04, dnnl)	5m 33s
check-python-style	10s
build-and-push-docker-images	26m 35s
build-python-wheels (windows-2022, auto64)	49m 45s
build-python-wheels (ubuntu-22.04, aarch64)	50m 1s
build-python-wheels (macos-13, arm64)	14m 9s
build-python-wheels (ubuntu-22.04, auto64)	33m 59s
build-python-wheels (macos-13, x86_64)	35m 3s
test-python-wheels	0s
build-and-deploy-docs	0s
publish-python-wheels-on-pypi	0s
	3h 46m 43s

Provide feedback