A new investigation has revealed the areas of Scotland that are most affected by rat and pest infestations, with the country overall seeing a surge in reports in recent years.