Well, one of the system updates has upgraded my smartphone OS from Android 9 to 10.
And that has fixed the problem.
Now my smartphone can work flawlessly at the same time as a Wi-Fi hotspot for external devices while maintaining Internet connection for itself.
Well done! I hope some of the next system updates will not revert the situation. :-)