Fix mypy error on scalar call with tuple[Any, ...]

Fix mypy error on scalar call with tuple[Any, ...]

Fixed issue in new :pep:`646` support for result sets where an issue in the
mypy type checker prevented "scalar" methods including
:meth:`.Connection.scalar`, :meth:`.Result.scalar`,
:meth:`_orm.Session.scalar`, as well as async versions of these methods
from applying the correct type to the scalar result value, when the columns
in the originating :func:`_sql.select` were typed as ``Any``.  Pull request
courtesy Yurii Karabas.

Fixes: #13091
Closes: #13092
Pull-request: https://github.com/sqlalchemy/sqlalchemy/pull/13092
Pull-request-sha: c0535dd7691c8b57d87fd5411cb0202866256fd6

Change-Id: Ifbebaf0bcfdda0dd293c3e278a639cd0c71d45cd