A massive search for a five-year-old boy in Wales ended when his six-year-old sister discovered him sleeping in the living room