MTL - The Queen’s Gigolo - Chapter 46

Hiro transmigrates and finds himself in the body of an orphan that’s about to be evicted from his orphanage. It wasn’t anything personal, but the orphanage’s policy doesn’t accommodate children who have reached the age of 16.From the gates of that humble establishment, Hiro slowly explores the facets of this world that was both familiar and unfamiliar due to its uncanny resemblance to his previous world—Earth.With his Daily Life RPG System urging him to excel in every aspect of his daily life, Hiro marks his presence in both the mundane and mystical circles of this new world.

The world that nurtured the civilization which reached the pinnacle of magic was on the verge of destruction.
The last survivor transmigrated to the past, when the magic civilization started growing, as countless mages were still fumbling their ways through the thorny paths of magic knowledge.
He, who came from the end of the magic era, aim to reach the pinnacle of magic.

- Description from Novelupdates

In the age of the Great Liang Dynasty, the lives of the people were made convenient with steam-powered machines that run on a fuel named Violetstream Gold. Chang Geng, who lived in a small countryside village, shared a distant relationship with his mother while his stepfather was away most of the year round, and the only people he was close to were two little kids, the village teacher, and his yi fu – adoptive father. But his life was flipped upside down one day following the barbaric Man tribes’ invasion, and it turned out that his entire identity had been an illusion – not only was Chang Geng himself not the country boy he thought he was, but also his mother, his teacher, and even his beloved yi fu…

Being given a chance and reincarnated is nice and all, yet why do I have to become that male friend who just watches the protagonist flirting with his harem?---World: Kaguya-sama: Love Is War - Hyouka ----