The small city has topped rankings as the UK's best value city, with average house prices of £206,900.