Research shows Scots living in the least well-off neighbourhoods are more likely to suffer from serious illness and less likely to survive a cancer diagnosis.