France's far-right National Rally (RN) have failed to win their first ever region, as results from the second round of regional elections come in.