Around 14,000 people are living with “chronic” cancer in Scotland but do not always get the support they need, research suggests.