Retail sales growth in Scotland was at its slowest rate in two and a half years in September, as consumer confidence and rising living costs squeezed spending.