Is it possible to scale a low resolution image to a highier resolution upto the point with minimum effect on quality, sharpness and other notable attributes of an image.
Sure, but why? If you have one red pixel, you can make that four red pixels at a slightly higher resolution or a billion red pixels at a lot higher resolution.
The image itself is the same, you're just spending four or a billion times the data to encode it.
What you might be asking is if you can take a one pixel picture of me, then make a four pixel image or a billion pixel image, each looking more accurately like me. And you can't do that. Or I mean, you could, but the picture would be wrong. It requires algorithms making educated guesses about what to fill in those missing pixels with. Some algorithms are decent at that, but unless they have a high resolution image of me already, it's all guesswork.