Lord Mayor of Leicester apologises for trouser drop