The tender moment when a 6-year-old boy said goodnight to his little sister for the last time was caught on camera and is breaking hearts around the world.