Two people in their 60s were found dead inside a vehicle connected to a car camping tent, triggering a police investigation.