With chic designs and queen-size mattresses, double-decker beds are being marketed to grown-ups, as our writer happily reports