It is, but, like council housing, there will be a wait for sheltered housing. In the meantime, it's likely you're already in, or get put in a regular council house.

Additionally, not all conditions require sheltered housing levels of care - they just mean you won't hold down a job.