Wales and Scotland secured dramatic late wins to move game away from qualification for the 2023 Women's World Cup.