Respect `requires-python` bounds in `get_supported_major_python_versions` for none-backend

At the moment, it's just using the version from the current interpreter.

We should:

- warn that the current interpreter is using an unsupported version
- use the highest supported version

Stop skipping tests which reference this issue