Average farmland prices dip, yet prime Scottish land remains highly sought after, with strong local demand shaping the market.