Emily Scarratt's late penalty secured a 20-18 victory for the Red Roses against France, which put them top of the table in the Women's Rugby Super Series.