An “exceptionally” drunk burglar who fell asleep in the kitchen armchair of the house he was raiding has been jailed for two years.