The UK and Republic of Ireland should abandon their 2030 World Cup bid and focus on hosting Euro 2028, says DCMS committee chair Julian Knight.