New analysis has suggested SNP ministers have cut Scottish councils’ core funding by almost £8 billion.