Wales have come close to ending their long winless streak in the Six Nations, but were agonisingly beaten 26-23 by Scotland with George Turner's late try.