The "most affordable" places in Scotland for first-time buyers have been revealed.