At least 10 people were killed when a man drove a pickup truck into a crowd celebrating New Year, before being shot by police.