A drive through Paris or Edinburgh in reverse (4)
I believe the answer is:
eros
'a drive' is the definition.
(Freudian drive)
'paris or edinburgh in reverse' is the wordplay.
'in' says the answer is hidden in the clue.
'reverse' says the letters should be written backwards.
'sore' is hidden within 'paris or edinburgh'.
'sore' backwards is 'EROS'.
'through' acts as a link.
(Other definitions for eros that I've seen before include "In Greek myth, the god of love" , "Group of instincts" , "Cupid, to the Greeks" , "Famous statue in Piccadilly, London" , "Greek name of Cupid" .)