Add workflows for Python 3.12 and newer PyQt6 versions

[karlch]

Test coverage for Python 3.12, PyQt6 6.6 and PyQt6 6.7.

Mypy still uses PyQt6 6.5 due to the larger number of changes required (many Optional[x] typings where we require x).