A Philippine mayor who paraded suspected drug dealers through the streets of his city is shot dead while attending a weekly flag-raising ceremony for government officials, police say.