The little boy, who was under the care of the state, was found unresponsive inside a vehicle parked outside a home. His family have shared their heartbreak over their 'worst nightmare'