A gunman in Louisiana killed eight children, including seven of his own, before being shot by police in one of the deadliest US mass shootings.