One of Scotland’s most famous shopping thoroughfares is facing retail “stagnation” as operators exit the street for other locations and its days at the forefront “look to be over”.