Yes, thanks to the in-built gyroscope, your iPhone will automatically detect a tripod when being used in Night Mode. It will adjust exposure to make it longer, thus allowing you to take photos with a high level of detail in dim light.