The answer to a recent question of mine was one of the Martian Chronicles by Ray Bradbury. This reminded me of my very first touch with SF.
It had to be in 1962 at the very latest because I remember exactly where I was sitting in my parents' earlier apartment, the one we left on December 31th, 1962. I read it in French (of course at that time I knew no English at all...) in a magazine, but not an SF magazine, rather a kind of "People" magazine, a tabloid, that just happened to have a page devoted to a (very) short story that was SF on this issue. (I assume it had a regular page devoted to a "short story" but I have no idea whether it was always SF or not.)
I don't know whether it was another one of the Martian Chronicles, and at that time I had of course no idea that this series existed. The name of Ray Bradbury was unknown to me so I would not have recognised it either. But now, more than 60 years later, I just made a possible connection. However, it might very well be by a totally different author. I have looked at the list of the Martian Chronicles on Wikipedia, but many are not detailed enough for me to determine if it is this story or not.
I remember very little, except that It did take place on Mars. IIRC, the POV character considered himself as a Martian. He was looking at Earth (just a point in space, but brighter than any star) and remembered the sad story of the Earthlings who had destroyed their own planet. Some of them had come to Mars, but I don't remember precisely what the POV character thought that happened to them.
Maybe I am mistaken, but IIRC the gist of the story seems to be that he himself was in fact a descendent of Earthlings, though he was convinced he was not. Indeed the last few words of the story is that, while looking sadly at Earth, he finds himself repeating a sound that makes no sense to him but he believes to be probably an obsolete very, very old word : "Terre, Terre.." (I assume it was "Earth, Earth..." in the original version)
EDIT
After Occam Shave found the answer, namely the french translation of Dark They Were, and Golden-Eyed by Ray Bradbury, which I recognized immediately despite my false memory of the nostalgic scene, a Martian uttering a Terran word he did not understand instead of the actual story, a Terran uttering a Martian word he did not understand, two questions remained.
First, we could not find any reference in ISFDB to a magazine publication, only a paperback collection published in 1961, which perfectly fit my memories as the latest possible year but also the most probable, since I only started Junior High in september 1961. Much earlier I would hardly have had enough maturity to appreciate such a story. Why no trace of this magazine publication about the same time ?
Second, why did I get the nostalgic scene reversed ?
I managed to get the full text of the story (in English). And I immediately understood the common answer. The story was much longer than the one I had read. But Occam Shave was still right, my story was indeed the one he suggested. But not all of it. Only a very abridged form. Two scenes I clearly recognized, the nostalgic one (even when reverse of what I thought I remembered) and the arrival of a rocket from Earth. That the Terrans of the rocket realised that the gentle dark and golden-eyed "natives" were certainly not guilty of destroying the Terran colony definitely struck a chord. Contrary to them, having the advantage of having read the story, I did understand that they were the Terrans having turned Martians.
But the detailed part between these two scenes, describing the steps of the transformation, did not look familiar to me, or at least not so long, and not with so many details. I am convinced it was very shortened in the version I read, and did not imprint in my memory. So after 60 years, I got the false feeling that the nostalgic scene, instead of being in fact one of the first signs of "martianisation" of a Terran, was instead one last remain of "terran-ness" of an almost-Martian, shortly before the transformation was completed.
So what I read was a abridged version, just a teaser for the whole collection (though of course a total spoiler for this particular story). This collection, a translation of A Medicine For Melancholy contains no less than 22 stories, and unless I am mistaken, only this one is a Martian Chronicle. Maybe the magazine even made it clear it was not the full story, I don't remember.
And since it was not the full story, but an abridged one, it makes sense that it was not listed in ISFDB !