The scenic city is built into the granite cliffs over the river Douro.