Investment in commercial property surged in Aberdeen last year, as bargain hunters took advantage of “extremely attractive yields”.