Scotland kicked off their Women’s Six Nations campaign with a hard-fought 24-21 win over long-time rivals Wales at Hive Stadium.